【问题:4.1】在sw_Commodity表中,字段sw_smallclassid关联商品小类表的sw_smallclassid字段,它是sw_Commodity表的外键,是商品小类表的 (1);如果某个商品被点击浏览了,那么该商品的点击数应该加1,使商品ID为“sw0001”的商品的点击数加1的SOL语句为(2);如果在查询商品时,需要按照商品点击数降序排序,那么需要在查询语句“select*from sw_Commodity”的后面加上 (3) ; 空(2)、(3)备选项如下: (2) A.update sw_Commodity set sw_chit=sw_chit+1 B.insert into sw_Commodity sw_chit=sw_chit+1 where sw_commodityid='sw0001' C.update sw_Commodity set sw_chit=sw_chit+1 where sw_commodityid='sw0001' D.update CommodityBase set sw_chit=sw_chit+1 where sw_commodityid='sw0001' (3) A.order by sw_chit desc B.order by sw_chit C.group by sw_chit desc D.order by sw_chit asc